IF exists(SELECT * FROM dbo.sysobjects WHERE name='fietsVrij' AND xtype='V') 
BEGIN
	DROP VIEW fietsVrij
END
GO

create view fietsVrij as

select n.fietsNr from fietsNr as n
 left join refterFiets as f
  on n.fietsNr=f.fietsNr
where f.fietsNr is null